package com.gaoxin.api.dao.edudao;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import com.gaoxin.api.entity.eduentity.Dept;
import com.gaoxin.api.entity.eduentity.StuScoreEntity;
import com.gaoxin.api.entity.statisentity.Course;

/**
 * 查询学生成绩接口-数据访问层
 *
 * @author fanyue
 * @email 859485490@qq.com
 * @date 2018-07-12 15:21
 */
@Mapper
public interface QueryStuScoreDao {

	/**
	 * 查询学生成绩信息
	 * 
	 * @param stuNumber
	 * @param year
	 * @param term
	 * @return List<StuInfoEntity>
	 */
	List<StuScoreEntity> queryStuScore(@Param("stuCode") String stuCode,@Param("year") String year,@Param("term") String term);
	/**
	 * 查询所有的二级院系
	 * @return
	 */
	public List<Dept> queryAllDept();
	/**
	 * 更具院系查询所属专业
	 * @param deptId
	 * @return
	 */
	public Dept queryMajorByDeptId(String deptId);
	/**
	 * 查询某门课程下所有学生的成绩
	 * @param courseId
	 * @param year
	 * @param term
	 * @return
	 */
	public Course queryCourseScores (@Param("courseId")String courseId,@Param("year")String year,@Param("term")String term);
	/**
	 * 
	 * @param year
	 * @param term
	 * @param deptId
	 * @param grade
	 * @return
	 */
	public List<StuScoreEntity> queryScores(@Param("year")String year,@Param("term")String term,@Param("deptId")String deptId,
			@Param("grade")String grade,@Param("stuNumber")String stuNumber ,@Param("courseId")String courseId);
	
	public List<StuScoreEntity> queryNoExam(@Param("year")String year,@Param("term")String term,@Param("deptId")String deptId,
	@Param("grade")String grade,@Param("stuNumber")String stuNumber,@Param("courseId")String courseId);
}
